﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Database" targetNamespace="http://tempuri.org/Database.xsd" xmlns:mstns="http://tempuri.org/Database.xsd" xmlns="http://tempuri.org/Database.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="YalaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="YalaConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Yala.UnitTests.Properties.Settings.GlobalReference.Default.YalaConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="YalaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="YalaConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Yala.UnitTests.Properties.Settings.GlobalReference.Default.YalaConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables />
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Database" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="Database" msprop:Generator_UserDSName="Database">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="UserProfiles" msprop:Generator_TableClassName="UserProfilesDataTable" msprop:Generator_TableVarName="tableUserProfiles" msprop:Generator_TablePropName="UserProfiles" msprop:Generator_RowDeletingName="UserProfilesRowDeleting" msprop:Generator_UserTableName="UserProfiles" msprop:Generator_RowChangingName="UserProfilesRowChanging" msprop:Generator_RowEvHandlerName="UserProfilesRowChangeEventHandler" msprop:Generator_RowDeletedName="UserProfilesRowDeleted" msprop:Generator_RowEvArgName="UserProfilesRowChangeEvent" msprop:Generator_RowChangedName="UserProfilesRowChanged" msprop:Generator_RowClassName="UserProfilesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnUserId" msprop:Generator_ColumnPropNameInRow="UserId" msprop:Generator_ColumnPropNameInTable="UserIdColumn" msprop:Generator_UserColumnName="UserId" type="xs:string" />
              <xs:element name="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" msprop:Generator_UserColumnName="FirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MiddleName" msprop:Generator_ColumnVarNameInTable="columnMiddleName" msprop:Generator_ColumnPropNameInRow="MiddleName" msprop:Generator_ColumnPropNameInTable="MiddleNameColumn" msprop:Generator_UserColumnName="MiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" msprop:Generator_UserColumnName="LastName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="AuthProviders" msprop:Generator_TableClassName="AuthProvidersDataTable" msprop:Generator_TableVarName="tableAuthProviders" msprop:Generator_TablePropName="AuthProviders" msprop:Generator_RowDeletingName="AuthProvidersRowDeleting" msprop:Generator_UserTableName="AuthProviders" msprop:Generator_RowChangingName="AuthProvidersRowChanging" msprop:Generator_RowEvHandlerName="AuthProvidersRowChangeEventHandler" msprop:Generator_RowDeletedName="AuthProvidersRowDeleted" msprop:Generator_RowEvArgName="AuthProvidersRowChangeEvent" msprop:Generator_RowChangedName="AuthProvidersRowChanged" msprop:Generator_RowClassName="AuthProvidersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AuthProviderId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnAuthProviderId" msprop:Generator_ColumnPropNameInRow="AuthProviderId" msprop:Generator_ColumnPropNameInTable="AuthProviderIdColumn" msprop:Generator_UserColumnName="AuthProviderId" type="xs:string" />
              <xs:element name="ProviderName" msprop:Generator_ColumnVarNameInTable="columnProviderName" msprop:Generator_ColumnPropNameInRow="ProviderName" msprop:Generator_ColumnPropNameInTable="ProviderNameColumn" msprop:Generator_UserColumnName="ProviderName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProviderServiceUrl" msprop:Generator_ColumnVarNameInTable="columnProviderServiceUrl" msprop:Generator_ColumnPropNameInRow="ProviderServiceUrl" msprop:Generator_ColumnPropNameInTable="ProviderServiceUrlColumn" msprop:Generator_UserColumnName="ProviderServiceUrl">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1024" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Items" msprop:Generator_TableClassName="ItemsDataTable" msprop:Generator_TableVarName="tableItems" msprop:Generator_TablePropName="Items" msprop:Generator_RowDeletingName="ItemsRowDeleting" msprop:Generator_UserTableName="Items" msprop:Generator_RowChangingName="ItemsRowChanging" msprop:Generator_RowEvHandlerName="ItemsRowChangeEventHandler" msprop:Generator_RowDeletedName="ItemsRowDeleted" msprop:Generator_RowEvArgName="ItemsRowChangeEvent" msprop:Generator_RowChangedName="ItemsRowChanged" msprop:Generator_RowClassName="ItemsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ItemId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnItemId" msprop:Generator_ColumnPropNameInRow="ItemId" msprop:Generator_ColumnPropNameInTable="ItemIdColumn" msprop:Generator_UserColumnName="ItemId" type="xs:string" />
              <xs:element name="ItemName" msprop:Generator_ColumnVarNameInTable="columnItemName" msprop:Generator_ColumnPropNameInRow="ItemName" msprop:Generator_ColumnPropNameInTable="ItemNameColumn" msprop:Generator_UserColumnName="ItemName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreatedDate" msprop:Generator_ColumnVarNameInTable="columnCreatedDate" msprop:Generator_ColumnPropNameInRow="CreatedDate" msprop:Generator_ColumnPropNameInTable="CreatedDateColumn" msprop:Generator_UserColumnName="CreatedDate" type="xs:dateTime" />
              <xs:element name="OwnerId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOwnerId" msprop:Generator_ColumnPropNameInRow="OwnerId" msprop:Generator_ColumnPropNameInTable="OwnerIdColumn" msprop:Generator_UserColumnName="OwnerId" type="xs:string" />
              <xs:element name="ParentId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnParentId" msprop:Generator_ColumnPropNameInRow="ParentId" msprop:Generator_ColumnPropNameInTable="ParentIdColumn" msprop:Generator_UserColumnName="ParentId" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_TablePropName="Users" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_UserTableName="Users" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowClassName="UsersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnUserId" msprop:Generator_ColumnPropNameInRow="UserId" msprop:Generator_ColumnPropNameInTable="UserIdColumn" msprop:Generator_UserColumnName="UserId" type="xs:string" />
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OpenId" msprop:Generator_ColumnVarNameInTable="columnOpenId" msprop:Generator_ColumnPropNameInRow="OpenId" msprop:Generator_ColumnPropNameInTable="OpenIdColumn" msprop:Generator_UserColumnName="OpenId">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AuthProviderId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnAuthProviderId" msprop:Generator_ColumnPropNameInRow="AuthProviderId" msprop:Generator_ColumnPropNameInTable="AuthProviderIdColumn" msprop:Generator_UserColumnName="AuthProviderId" type="xs:string" />
              <xs:element name="LastLogOnDate" msprop:Generator_ColumnVarNameInTable="columnLastLogOnDate" msprop:Generator_ColumnPropNameInRow="LastLogOnDate" msprop:Generator_ColumnPropNameInTable="LastLogOnDateColumn" msprop:Generator_UserColumnName="LastLogOnDate" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserProfiles" />
      <xs:field xpath="mstns:UserId" />
    </xs:unique>
    <xs:unique name="AuthProviders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:AuthProviders" />
      <xs:field xpath="mstns:AuthProviderId" />
    </xs:unique>
    <xs:unique name="Items_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Items" />
      <xs:field xpath="mstns:ItemId" />
    </xs:unique>
    <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:UserId" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Items_Users" msdata:parent="Users" msdata:child="Items" msdata:parentkey="UserId" msdata:childkey="OwnerId" msprop:Generator_UserChildTable="Items" msprop:Generator_ChildPropName="GetItemsRows" msprop:Generator_ParentPropName="UsersRow" msprop:Generator_UserRelationName="FK_Items_Users" msprop:Generator_RelationVarName="relationFK_Items_Users" msprop:Generator_UserParentTable="Users" />
      <msdata:Relationship name="FK_AuthProviderId" msdata:parent="AuthProviders" msdata:child="Users" msdata:parentkey="AuthProviderId" msdata:childkey="AuthProviderId" msprop:Generator_UserChildTable="Users" msprop:Generator_ChildPropName="GetUsersRows" msprop:Generator_ParentPropName="AuthProvidersRow" msprop:Generator_UserRelationName="FK_AuthProviderId" msprop:Generator_RelationVarName="relationFK_AuthProviderId" msprop:Generator_UserParentTable="AuthProviders" />
      <msdata:Relationship name="FK_UserProfiles_Users" msdata:parent="Users" msdata:child="UserProfiles" msdata:parentkey="UserId" msdata:childkey="UserId" msprop:Generator_UserChildTable="UserProfiles" msprop:Generator_ChildPropName="GetUserProfilesRows" msprop:Generator_ParentPropName="UsersRow" msprop:Generator_UserRelationName="FK_UserProfiles_Users" msprop:Generator_RelationVarName="relationFK_UserProfiles_Users" msprop:Generator_UserParentTable="Users" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>